|
Book details / order |
SQL & PL/SQL FOR ORACLE 10G BLACK BOOK |
The book brings to you the complete, latest account of sql and pl/sql for oracle. it gifts you two things - 1st, it upgrades your knowledge on the subject and 2nd, the innumerable, exciting examples help you build a better skill in sql and pl/sql. this comprehensive reference will help you learn the entire spectrum of sql - from views to cube and roll up; from case expressions to variances and corelation - and pl/sql - from collections to objecttypes; from error handling to triggers; from object views to rollback segments; from undo tablespace to expression filter and many more.
-----------------------------------------------------------------------------------------------------
? introduction to sql
? set operations
? sql operators
? aggregate functions and group by clause
? updating and deleting data in existing table (dml)
? views
? assignment - i
? assignment - ii
? advanced queries
? integrity constraints
? analytical queries
? understanding rollup and cube
? understanding joins
? scalar subqueries
? case expressions
? multitable insert and merge
? regular expression
? statistical functions
? model queries
? sql quiz
? pl/sql program features
? pl/sql datatypes
? understanding control structure
? interaction with oracle
? collections and records
? lob, bfile and dbms_lob
? objects and objects types
? sample programs - i
? sample programs - ii
? error handling
? subprograms in pl/sql
? package
? trigger (database)
? autonomous transaction
? important pl/sql packages
? object views
? transaction processing in oracle
? locking in oracle
? rollback segments
? undo tablespace
? invoker rights and nocopy clause
? dependency tracking in oracle
? falshback queries
? sequence
? pl/sql wrapper
? oracle expression filter
? server model for billing entry system
? security and auditing
? pl/sql questions
Author : P.s. deshpande
Publication : Black book
Isbn : 9788177227109
Store book number : 107
NRS 910.00
|
|
|
|
|
|
|
|
|
|